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_PAYJPSMT_XMLP_PKG dependencies on PAY_JP_BALANCE_PKG

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

27:
28: G_BLOCK_COUNT :=1;
29: G_REC_COUNT :=0;
30:
31: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
32:
33: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
34: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
35:

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

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

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

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

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

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

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

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

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

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

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

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

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

38: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
39: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
40:
41: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
42: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

Line 43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');

39: G_WP_COMP_APPLIED_DATE_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
40:
41: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
42: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

Line 44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');

40:
41: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
42: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');

Line 45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');

41: IF p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
42: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

Line 46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

42: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_BEFORE_20030331_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

Line 47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

43: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');

Line 48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');

44: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE

Line 49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

45: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUL');
46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

46: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');

Line 51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');

47: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
48: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUL');
49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');

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

49: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');

Line 54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');

50: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

Line 55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');

51: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUL');
52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

Line 56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');

52: ELSE
53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');

Line 57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');

53: G_SANTEI_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

Line 58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');

54: G_PAYMENT_DAYS3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_APR');
55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

Line 59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');

55: G_PAYMENT_DAYS2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_MAY');
56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;

Line 60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');

56: G_PAYMENT_DAYS1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'PAY_BASE_DAYS_JUN');
57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;
64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');

Line 61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');

57: G_SIMPLE_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_APR');
58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;
64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');

Line 62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');

58: G_SIMPLE_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_MAY');
59: G_SIMPLE_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_MONEY_JUN');
60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;
64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');

Line 64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');

60: G_SIMPLE_MTR_COMP3_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_APR');
61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;
64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
67:
68: 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 65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');

61: G_SIMPLE_MTR_COMP2_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_MAY');
62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;
64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
67:
68: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
69: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');

Line 66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');

62: G_SIMPLE_MTR_COMP1_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'ERN_KIND_JUN');
63: END IF;
64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
67:
68: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
69: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
70:

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

64: G_SIMPLE_COMP_TOTAL_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'TOTAL');
65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
67:
68: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
69: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
70:
71: G_SANTEI_GEPPEN_MTH_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_GEP_MTH_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
72: G_KOUNEN_MTH_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_GEPPEN_MTH_ELM_ID,'WP');

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

65: G_SIMPLE_COMP_AVG_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'SIMPLE_AVG');
66: G_ADJUSTED_COMP_AVG_IV_ID:= pay_jp_balance_pkg.get_input_value_id(G_SANTEI_ELM_ID,'CORRECT_AVG');
67:
68: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
69: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
70:
71: G_SANTEI_GEPPEN_MTH_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_GEP_MTH_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
72: G_KOUNEN_MTH_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_GEPPEN_MTH_ELM_ID,'WP');
73: IF P_DATE_EARNED < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN

Line 71: G_SANTEI_GEPPEN_MTH_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_GEP_MTH_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);

67:
68: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
69: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
70:
71: G_SANTEI_GEPPEN_MTH_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_GEP_MTH_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
72: G_KOUNEN_MTH_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_GEPPEN_MTH_ELM_ID,'WP');
73: IF P_DATE_EARNED < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
74: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),
75: l_date_era_code,

Line 72: G_KOUNEN_MTH_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_GEPPEN_MTH_ELM_ID,'WP');

68: G_SANTEI_BIKOU_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_REPORT_RMKS_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
69: G_PART_TIMER_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_BIKOU_ELM_ID,'SHORT_TIME_WORKER_FLAG');
70:
71: G_SANTEI_GEPPEN_MTH_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_GEP_MTH_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
72: G_KOUNEN_MTH_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_GEPPEN_MTH_ELM_ID,'WP');
73: IF P_DATE_EARNED < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
74: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),
75: l_date_era_code,
76: l_date_year,

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

111: G_REC_COUNT := 0;
112: G_BLOCK_COUNT := G_BLOCK_COUNT + 1;
113: end if;
114:
115: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(G_SI_SEX_IV_ID,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_SI_SEX := hr_general.decode_lookup('JP_SI_SEX',CP_SI_SEX_CODE);
117:
118: if nvl(to_char(ASSIGNMENT_ACTION_ID),' ') = ' ' then
119: CP_DISQUALIFIED := 'Yes';

Line 130: CP_GEPPEN_MTH := nvl(to_char(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_GEPPEN_MTH_ELM_ID,G_KOUNEN_MTH_IV_ID,ASSIGNMENT_ACTION_ID)),' ');

126: if CP_DISQUALIFIED = 'Yes' then
127: CP_GEPPEN_MTH := ' ';
128: CP_DISQUALIFIED_CNT := CP_DISQUALIFIED_CNT + 1;
129: else
130: CP_GEPPEN_MTH := nvl(to_char(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_GEPPEN_MTH_ELM_ID,G_KOUNEN_MTH_IV_ID,ASSIGNMENT_ACTION_ID)),' ');
131: if CP_GEPPEN_MTH = ' ' then
132: CP_SANTEI_CNT := CP_SANTEI_CNT + 1;
133: else
134: if p_date_earned < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN

Line 171: 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');

167: g_wp_old_comp_iv_id,
168: l_wp_applied_date_old,
169: l_wp_std_monthly_comp_old);
170: CP_WP_STD_MONTHLY_COMP_OLD := lpad(to_char(floor(to_number(nvl(l_wp_std_monthly_comp_old,'0'))/1000)),4,'0');
171: 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');
172:
173: CP_PAYMENT_DAYS_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 173: CP_PAYMENT_DAYS_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);

169: l_wp_std_monthly_comp_old);
170: CP_WP_STD_MONTHLY_COMP_OLD := lpad(to_char(floor(to_number(nvl(l_wp_std_monthly_comp_old,'0'))/1000)),4,'0');
171: 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');
172:
173: CP_PAYMENT_DAYS_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);

170: CP_WP_STD_MONTHLY_COMP_OLD := lpad(to_char(floor(to_number(nvl(l_wp_std_monthly_comp_old,'0'))/1000)),4,'0');
171: 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');
172:
173: CP_PAYMENT_DAYS_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);

171: 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');
172:
173: CP_PAYMENT_DAYS_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

173: CP_PAYMENT_DAYS_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS3_IV_ID,ASSIGNMENT_ACTION_ID),0);
174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

174: CP_PAYMENT_DAYS_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS2_IV_ID,ASSIGNMENT_ACTION_ID),0);
175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

175: CP_PAYMENT_DAYS_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_PAYMENT_DAYS1_IV_ID,ASSIGNMENT_ACTION_ID),0);
176:
177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

Line 181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);

177: CP_SIMPLE_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
184:
185: CP_SIMPLE_COMP_TOTAL_MAY := CP_SIMPLE_COMP_MAY + CP_SIMPLE_MTR_COMP_MAY;

Line 182: CP_SIMPLE_MTR_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);

178: CP_SIMPLE_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
184:
185: CP_SIMPLE_COMP_TOTAL_MAY := CP_SIMPLE_COMP_MAY + CP_SIMPLE_MTR_COMP_MAY;
186: CP_SIMPLE_COMP_TOTAL_JUN := CP_SIMPLE_COMP_JUN + CP_SIMPLE_MTR_COMP_JUN;

Line 183: CP_SIMPLE_MTR_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);

179: CP_SIMPLE_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
180:
181: CP_SIMPLE_MTR_COMP_MAY := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP3_IV_ID,ASSIGNMENT_ACTION_ID),0);
182: CP_SIMPLE_MTR_COMP_JUN := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP2_IV_ID,ASSIGNMENT_ACTION_ID),0);
183: CP_SIMPLE_MTR_COMP_JUL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_SIMPLE_MTR_COMP1_IV_ID,ASSIGNMENT_ACTION_ID),0);
184:
185: CP_SIMPLE_COMP_TOTAL_MAY := CP_SIMPLE_COMP_MAY + CP_SIMPLE_MTR_COMP_MAY;
186: CP_SIMPLE_COMP_TOTAL_JUN := CP_SIMPLE_COMP_JUN + CP_SIMPLE_MTR_COMP_JUN;
187: CP_SIMPLE_COMP_TOTAL_JUL := CP_SIMPLE_COMP_JUL + CP_SIMPLE_MTR_COMP_JUL;

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

185: CP_SIMPLE_COMP_TOTAL_MAY := CP_SIMPLE_COMP_MAY + CP_SIMPLE_MTR_COMP_MAY;
186: CP_SIMPLE_COMP_TOTAL_JUN := CP_SIMPLE_COMP_JUN + CP_SIMPLE_MTR_COMP_JUN;
187: CP_SIMPLE_COMP_TOTAL_JUL := CP_SIMPLE_COMP_JUL + CP_SIMPLE_MTR_COMP_JUL;
188:
189: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_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_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_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_SIMPLE_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID),0);

187: CP_SIMPLE_COMP_TOTAL_JUL := CP_SIMPLE_COMP_JUL + CP_SIMPLE_MTR_COMP_JUL;
188:
189: CP_SIMPLE_COMP_TOTAL := nvl(pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_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_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_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
194:
195: if nvl(g_effective_date,to_date('4712/12/31','YYYY/MM/DD')) <> trunc(effective_date,'DD') then

Line 193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_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_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_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_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
194:
195: if nvl(g_effective_date,to_date('4712/12/31','YYYY/MM/DD')) <> trunc(effective_date,'DD') then
196: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
197: g_g_kyou_sangep_pay_day := get_global_value('G_COM_PAY_BASE_DAYS_MIN',p_business_group_id,l_legislation_code,effective_date);

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

192:
193: CP_ADJUSTED_COMP_AVG := pay_jp_balance_pkg.get_result_value_number(G_SANTEI_ELM_ID,G_ADJUSTED_COMP_AVG_IV_ID,ASSIGNMENT_ACTION_ID);
194:
195: if nvl(g_effective_date,to_date('4712/12/31','YYYY/MM/DD')) <> trunc(effective_date,'DD') then
196: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
197: g_g_kyou_sangep_pay_day := get_global_value('G_COM_PAY_BASE_DAYS_MIN',p_business_group_id,l_legislation_code,effective_date);
198: g_effective_date := trunc(effective_date,'DD');
199: end if;
200: l_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 200: l_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: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
197: g_g_kyou_sangep_pay_day := get_global_value('G_COM_PAY_BASE_DAYS_MIN',p_business_group_id,l_legislation_code,effective_date);
198: g_effective_date := trunc(effective_date,'DD');
199: end if;
200: l_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');
201: if cp_payment_days_may < nvl(g_g_kyou_sangep_pay_day,0)
202: and cp_payment_days_jun < nvl(g_g_kyou_sangep_pay_day,0)
203: and cp_payment_days_jul < nvl(g_g_kyou_sangep_pay_day,0)
204: and l_part_timer_flag = 'Yes' then

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

342: l_applied_mth varchar2(60);
343: l_applied_mth_old varchar2(60);
344: l_std_mth_comp_old varchar2(60);
345: begin
346: l_applied_mth := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id,p_assignment_id,p_effective_date);
347: 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);
348: if trunc(to_date(nvl(l_applied_mth_one_day_before,'000101')||'01','YYYYMMDD'),'MM')
349: < trunc(p_date_earned,'MM') then
350: l_applied_mth_old := l_applied_mth_one_day_before;

Line 347: 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);

343: l_applied_mth_old varchar2(60);
344: l_std_mth_comp_old varchar2(60);
345: begin
346: l_applied_mth := pay_jp_balance_pkg.get_entry_value_char(p_applied_mth_iv_id,p_assignment_id,p_effective_date);
347: 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);
348: if trunc(to_date(nvl(l_applied_mth_one_day_before,'000101')||'01','YYYYMMDD'),'MM')
349: < trunc(p_date_earned,'MM') then
350: l_applied_mth_old := l_applied_mth_one_day_before;
351: if nvl(l_applied_mth,'000101') <> nvl(l_applied_mth_one_day_before,'000101') then

Line 352: 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);

348: if trunc(to_date(nvl(l_applied_mth_one_day_before,'000101')||'01','YYYYMMDD'),'MM')
349: < trunc(p_date_earned,'MM') then
350: l_applied_mth_old := l_applied_mth_one_day_before;
351: if nvl(l_applied_mth,'000101') <> nvl(l_applied_mth_one_day_before,'000101') then
352: 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);
353: else
354: if l_applied_mth is not null and l_applied_mth_one_day_before is not null then
355:
356: 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);

Line 356: 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);

352: 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);
353: else
354: if l_applied_mth is not null and l_applied_mth_one_day_before is not null then
355:
356: 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);
357: end if;
358: end if;
359: else
360: open csr_past_std_mth_comp;