eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYJPGMT_XMLP_PKG dependencies on PAY_JP_BALANCE_PKG

Line 27: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);

23:
24: G_BLOCK_COUNT :=1;
25: G_REC_COUNT :=0;
26:
27: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
28:
29: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
30:
31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');

Line 29: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

25: G_REC_COUNT :=0;
26:
27: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
28:
29: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
30:
31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');

27: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
28:
29: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
30:
31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
34: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');

Line 33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

29: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
30:
31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
34: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
37:

Line 34: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');

30:
31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
34: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
37:
38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN

Line 35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');

31: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
34: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
37:
38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');

32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
34: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
37:
38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');

Line 39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

35: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
37:
38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

Line 40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');

36: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
37:
38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

Line 41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');

37:
38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');

Line 42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');

38: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

Line 43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

39: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

Line 44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

40: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
48: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');

Line 45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');

41: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
48: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
49: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),

Line 46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

42: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
48: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
49: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),
50: l_date_era_code,

Line 47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

43: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
48: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
49: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),
50: l_date_era_code,
51: l_date_year,

Line 48: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');

44: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
45: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
46: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
47: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
48: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
49: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),
50: l_date_era_code,
51: l_date_year,
52: l_date_month,

Line 55: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

51: l_date_year,
52: l_date_month,
53: l_date_day);
54: ELSE
55: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');

Line 56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');

52: l_date_month,
53: l_date_day);
54: ELSE
55: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

Line 57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');

53: l_date_day);
54: ELSE
55: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

Line 58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');

54: ELSE
55: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');

Line 59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');

55: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

Line 60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

56: G_SAN_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
64: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

Line 61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

57: G_SAN_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
64: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
65: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD'),

Line 62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');

58: G_SAN_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
64: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
65: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD'),
66: l_date_era_code,

Line 63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

59: G_SAN_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
64: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
65: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD'),
66: l_date_era_code,
67: l_date_year,

Line 64: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

60: G_SAN_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
61: G_SAN_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
62: G_SAN_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
63: G_SAN_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
64: G_SAN_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
65: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD'),
66: l_date_era_code,
67: l_date_year,
68: l_date_month,

Line 71: G_SAN_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');

67: l_date_year,
68: l_date_month,
69: l_date_day);
70: END IF;
71: G_SAN_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
72: G_SAN_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
73: G_SAN_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
74:
75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 72: G_SAN_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');

68: l_date_month,
69: l_date_day);
70: END IF;
71: G_SAN_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
72: G_SAN_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
73: G_SAN_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
74:
75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');

Line 73: G_SAN_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');

69: l_date_day);
70: END IF;
71: G_SAN_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
72: G_SAN_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
73: G_SAN_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
74:
75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
77:

Line 75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

71: G_SAN_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
72: G_SAN_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
73: G_SAN_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
74:
75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
77:
78:
79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');

72: G_SAN_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
73: G_SAN_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
74:
75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
77:
78:
79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');

Line 79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

75: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
77:
78:
79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');
81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');

Line 80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');

76: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
77:
78:
79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');
81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');

Line 81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');

77:
78:
79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');
81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');

Line 82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');

78:
79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');
81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');

Line 83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');

79: G_GEPPEN_ELM_ID := pay_jp_balance_pkg.get_element_type_id('GEP_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');
81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');

Line 84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');

80: G_GEP_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_3MTH_AGO');
81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');

Line 85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');

81: G_GEP_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_2MTH_AGO');
82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');

Line 86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');

82: G_GEP_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'PAY_BASE_DAYS_1MTH_AGO');
83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');
90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');

Line 87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');

83: G_GEP_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_3MTH_AGO');
84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');
90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');
91: G_GEP_ADJUSTED_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'CORRECT_AVG');

Line 88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');

84: G_GEP_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_2MTH_AGO');
85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');
90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');
91: G_GEP_ADJUSTED_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'CORRECT_AVG');
92:

Line 89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');

85: G_GEP_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_MONEY_1MTH_AGO');
86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');
90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');
91: G_GEP_ADJUSTED_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'CORRECT_AVG');
92:
93: l_date_year := l_date_year - trunc(l_date_year,-2);

Line 90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');

86: G_GEP_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_3MTH_AGO');
87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');
90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');
91: G_GEP_ADJUSTED_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'CORRECT_AVG');
92:
93: l_date_year := l_date_year - trunc(l_date_year,-2);
94: G_SANTEI_DATE_APPLIED_YYMM := lpad(to_char(l_date_year),2,'0') || lpad(to_char(l_date_month),2,'0');

Line 91: G_GEP_ADJUSTED_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'CORRECT_AVG');

87: G_GEP_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_2MTH_AGO');
88: G_GEP_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'ERN_KIND_1MTH_AGO');
89: G_GEP_SIMPLE_COMP_TOTAL_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'TOTAL');
90: G_GEP_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'SIMPLE_AVG');
91: G_GEP_ADJUSTED_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_GEPPEN_ELM_ID,'CORRECT_AVG');
92:
93: l_date_year := l_date_year - trunc(l_date_year,-2);
94: G_SANTEI_DATE_APPLIED_YYMM := lpad(to_char(l_date_year),2,'0') || lpad(to_char(l_date_month),2,'0');
95:

Line 135: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(G_SI_SEX_IV_ID,ASSIGNMENT_ID,EFFECTIVE_DATE);

131: G_REC_COUNT := 0;
132: G_BLOCK_COUNT := G_BLOCK_COUNT + 1;
133: end if;
134:
135: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(G_SI_SEX_IV_ID,ASSIGNMENT_ID,EFFECTIVE_DATE);
136: CP_SI_SEX := hr_general.decode_lookup('JP_SI_SEX',CP_SI_SEX_CODE);
137:
138: get_latest_std_mth_comp_info(
139: assignment_id,

Line 153: CP_WP_STD_MONTHLY_COMP_NEW := lpad(to_char(floor(nvl(pay_jp_balance_pkg.get_entry_value_number(G_WP_NEW_COMP_IV_ID,ASSIGNMENT_ID,EFFECTIVE_DATE),0))/1000),4,'0');

149: cp_wp_std_monthly_comp_old := NULL;
150: ELSE
151: CP_WP_STD_MONTHLY_COMP_OLD := lpad(to_char(floor(to_number(l_wp_std_monthly_comp_old)/1000)),4,'0');
152: END IF;
153: CP_WP_STD_MONTHLY_COMP_NEW := lpad(to_char(floor(nvl(pay_jp_balance_pkg.get_entry_value_number(G_WP_NEW_COMP_IV_ID,ASSIGNMENT_ID,EFFECTIVE_DATE),0))/1000),4,'0');
154:
155: CP_TOTAL_CNT := CP_TOTAL_CNT + 1;
156:
157: if APPLIED_CATEGORY = 'S' then

Line 173: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);

169: CP_2MTH_AGO := 5;
170: CP_1MTH_AGO := 6;
171: END IF;
172:
173: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 174: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);

170: CP_1MTH_AGO := 6;
171: END IF;
172:
173: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);

171: END IF;
172:
173: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

173: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

174: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

175: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

177: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
184:
185: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;

Line 182: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

178: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
184:
185: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;
186: CP_SIMPLE_COMP_TOTAL_2MTH_AGO := CP_SIMPLE_COMP_2MTH_AGO + CP_SIMPLE_MTR_COMP_2MTH_AGO;

Line 183: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

179: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
184:
185: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;
186: CP_SIMPLE_COMP_TOTAL_2MTH_AGO := CP_SIMPLE_COMP_2MTH_AGO + CP_SIMPLE_MTR_COMP_2MTH_AGO;
187: CP_SIMPLE_COMP_TOTAL_1MTH_AGO := CP_SIMPLE_COMP_1MTH_AGO + CP_SIMPLE_MTR_COMP_1MTH_AGO;

Line 189: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);

185: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;
186: CP_SIMPLE_COMP_TOTAL_2MTH_AGO := CP_SIMPLE_COMP_2MTH_AGO + CP_SIMPLE_MTR_COMP_2MTH_AGO;
187: CP_SIMPLE_COMP_TOTAL_1MTH_AGO := CP_SIMPLE_COMP_1MTH_AGO + CP_SIMPLE_MTR_COMP_1MTH_AGO;
188:
189: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);
190:
191: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
192:
193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);

Line 191: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);

187: CP_SIMPLE_COMP_TOTAL_1MTH_AGO := CP_SIMPLE_COMP_1MTH_AGO + CP_SIMPLE_MTR_COMP_1MTH_AGO;
188:
189: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);
190:
191: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
192:
193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
194:
195: CP_PART_TIMER_FLAG := nvl(pay_jp_balance_pkg.get_result_value_char(G_SANTEI_BIKOU_ELM_ID,G_PART_TIMER_IV_ID,ASSIGNMENT_ACTION_ID),'No');

Line 193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);

189: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);
190:
191: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
192:
193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
194:
195: CP_PART_TIMER_FLAG := nvl(pay_jp_balance_pkg.get_result_value_char(G_SANTEI_BIKOU_ELM_ID,G_PART_TIMER_IV_ID,ASSIGNMENT_ACTION_ID),'No');
196:
197: else

Line 195: CP_PART_TIMER_FLAG := nvl(pay_jp_balance_pkg.get_result_value_char(G_SANTEI_BIKOU_ELM_ID,G_PART_TIMER_IV_ID,ASSIGNMENT_ACTION_ID),'No');

191: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
192:
193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SAN_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
194:
195: CP_PART_TIMER_FLAG := nvl(pay_jp_balance_pkg.get_result_value_char(G_SANTEI_BIKOU_ELM_ID,G_PART_TIMER_IV_ID,ASSIGNMENT_ACTION_ID),'No');
196:
197: else
198:
199: CP_GEPPEN_CNT := CP_GEPPEN_CNT + 1;

Line 208: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);

204: CP_3MTH_AGO := to_number(to_char(add_months(P_DATE_EARNED,-3),'MM'));
205: CP_2MTH_AGO := to_number(to_char(add_months(P_DATE_EARNED,-2),'MM'));
206: CP_1MTH_AGO := to_number(to_char(add_months(P_DATE_EARNED,-1),'MM'));
207:
208: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
209: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
211:
212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 209: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);

205: CP_2MTH_AGO := to_number(to_char(add_months(P_DATE_EARNED,-2),'MM'));
206: CP_1MTH_AGO := to_number(to_char(add_months(P_DATE_EARNED,-1),'MM'));
207:
208: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
209: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
211:
212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);

206: CP_1MTH_AGO := to_number(to_char(add_months(P_DATE_EARNED,-1),'MM'));
207:
208: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
209: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
211:
212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

208: CP_PAYMENT_DAYS_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
209: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
211:
212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
215:
216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

209: CP_PAYMENT_DAYS_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
211:
212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
215:
216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
217: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

210: CP_PAYMENT_DAYS_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
211:
212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
215:
216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
217: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
218: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

212: CP_SIMPLE_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
215:
216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
217: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
218: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
219:
220: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;

Line 217: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

213: CP_SIMPLE_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
215:
216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
217: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
218: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
219:
220: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;
221: CP_SIMPLE_COMP_TOTAL_2MTH_AGO := CP_SIMPLE_COMP_2MTH_AGO + CP_SIMPLE_MTR_COMP_2MTH_AGO;

Line 218: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

214: CP_SIMPLE_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
215:
216: CP_SIMPLE_MTR_COMP_3MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
217: CP_SIMPLE_MTR_COMP_2MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
218: CP_SIMPLE_MTR_COMP_1MTH_AGO := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
219:
220: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;
221: CP_SIMPLE_COMP_TOTAL_2MTH_AGO := CP_SIMPLE_COMP_2MTH_AGO + CP_SIMPLE_MTR_COMP_2MTH_AGO;
222: CP_SIMPLE_COMP_TOTAL_1MTH_AGO := CP_SIMPLE_COMP_1MTH_AGO + CP_SIMPLE_MTR_COMP_1MTH_AGO;

Line 224: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);

220: CP_SIMPLE_COMP_TOTAL_3MTH_AGO := CP_SIMPLE_COMP_3MTH_AGO + CP_SIMPLE_MTR_COMP_3MTH_AGO;
221: CP_SIMPLE_COMP_TOTAL_2MTH_AGO := CP_SIMPLE_COMP_2MTH_AGO + CP_SIMPLE_MTR_COMP_2MTH_AGO;
222: CP_SIMPLE_COMP_TOTAL_1MTH_AGO := CP_SIMPLE_COMP_1MTH_AGO + CP_SIMPLE_MTR_COMP_1MTH_AGO;
223:
224: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);
225:
226: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
227:
228: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);

Line 226: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);

222: CP_SIMPLE_COMP_TOTAL_1MTH_AGO := CP_SIMPLE_COMP_1MTH_AGO + CP_SIMPLE_MTR_COMP_1MTH_AGO;
223:
224: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);
225:
226: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
227:
228: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
229:
230: CP_PART_TIMER_FLAG := ' ';

Line 228: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);

224: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_TOTAL_IV_ID,ASSIGNMENT_ACTION_ID),0);
225:
226: CP_SIMPLE_COMP_AVG := nvl(pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);
227:
228: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_GEPPEN_ELM_ID,G_GEP_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
229:
230: CP_PART_TIMER_FLAG := ' ';
231: end if;
232:

Line 332: l_applied_mth := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id, p_assignment_id, p_effective_date);

328: l_applied_mth_old VARCHAR2(60);
329: l_std_mth_comp_old VARCHAR2(60);
330: --pragma autonomous_transaction;
331: BEGIN
332: l_applied_mth := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id, p_assignment_id, p_effective_date);
333: l_applied_mth_one_day_before := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id, p_assignment_id, p_effective_date -1);
334:
335: IF TRUNC(to_date(nvl(l_applied_mth_one_day_before, '000101') || '01', 'YYYYMMDD'), 'MM') < TRUNC(p_date_earned, 'MM') THEN
336: l_applied_mth_old := l_applied_mth_one_day_before;

Line 333: l_applied_mth_one_day_before := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id, p_assignment_id, p_effective_date -1);

329: l_std_mth_comp_old VARCHAR2(60);
330: --pragma autonomous_transaction;
331: BEGIN
332: l_applied_mth := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id, p_assignment_id, p_effective_date);
333: l_applied_mth_one_day_before := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id, p_assignment_id, p_effective_date -1);
334:
335: IF TRUNC(to_date(nvl(l_applied_mth_one_day_before, '000101') || '01', 'YYYYMMDD'), 'MM') < TRUNC(p_date_earned, 'MM') THEN
336: l_applied_mth_old := l_applied_mth_one_day_before;
337:

Line 339: l_std_mth_comp_old := pay_jp_balance_pkg.get_entry_value_char(p_old_std_mth_comp_iv_id, p_assignment_id, p_effective_date);

335: IF TRUNC(to_date(nvl(l_applied_mth_one_day_before, '000101') || '01', 'YYYYMMDD'), 'MM') < TRUNC(p_date_earned, 'MM') THEN
336: l_applied_mth_old := l_applied_mth_one_day_before;
337:
338: IF nvl(l_applied_mth, '000101') <> nvl(l_applied_mth_one_day_before, '000101') THEN
339: l_std_mth_comp_old := pay_jp_balance_pkg.get_entry_value_char(p_old_std_mth_comp_iv_id, p_assignment_id, p_effective_date);
340:
341: ELSE
342:
343: IF l_applied_mth IS NOT NULL

Line 346: l_std_mth_comp_old := pay_jp_balance_pkg.get_entry_value_char(p_new_std_mth_comp_iv_id, p_assignment_id, p_date_earned);

342:
343: IF l_applied_mth IS NOT NULL
344: AND l_applied_mth_one_day_before IS NOT NULL THEN
345:
346: l_std_mth_comp_old := pay_jp_balance_pkg.get_entry_value_char(p_new_std_mth_comp_iv_id, p_assignment_id, p_date_earned);
347: END IF;
348:
349: END IF;
350: