APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_BALANCE_TYPES

Line 417: pay_balance_types blt

413: pay_run_result_values rrv,
414: pay_element_types_f ele,
415: pay_input_values_f ipv,
416: pay_balance_feeds_f blf,
417: pay_balance_types blt
418: WHERE asa.assignment_id = p_asg_id
419: AND asa.tax_unit_id = p_gre
420: AND pya.payroll_id = p_payroll_id
421: AND pya.payroll_action_id = asa.payroll_action_id

Line 461: pay_balance_types blt

457: pay_run_result_values rrv,
458: pay_element_types_f ele,
459: pay_input_values_f ipv,
460: pay_balance_feeds_f blf,
461: pay_balance_types blt
462: WHERE asa.assignment_id = p_asg_id
463: AND asa.tax_unit_id = p_gre
464: AND pya.payroll_id = p_payroll_id
465: AND pya.payroll_action_id = asa.payroll_action_id

Line 501: pay_balance_types blt

497: pay_run_result_values rrv,
498: pay_element_types_f ele,
499: pay_input_values_f ipv,
500: pay_balance_feeds_f blf,
501: pay_balance_types blt
502: WHERE asa.assignment_id = p_asg_id
503: AND asa.tax_unit_id = p_gre
504: AND pya.payroll_id = p_payroll_id
505: AND pya.payroll_action_id = asa.payroll_action_id

Line 545: pay_balance_types blt

541: pay_run_result_values rrv,
542: pay_element_types_f ele,
543: pay_input_values_f ipv,
544: pay_balance_feeds_f blf,
545: pay_balance_types blt
546: WHERE asa.assignment_id = p_asg_id
547: AND asa.tax_unit_id = p_gre
548: AND pya.payroll_id = p_payroll_id
549: AND pya.payroll_action_id = asa.payroll_action_id

Line 694: pay_balance_types blt

690: pay_element_types_f ele,
691: pay_element_classifications elc,
692: pay_input_values_f ipv,
693: pay_balance_feeds_f blf,
694: pay_balance_types blt
695: WHERE asa.assignment_id = p_asg_id
696: AND asa.tax_unit_id = p_gre
697: AND pya.payroll_id = p_payroll_id
698: AND pya.payroll_action_id = asa.payroll_action_id

Line 850: pay_balance_types blt

846: pay_element_types_f ele,
847: pay_element_classifications elc,
848: pay_input_values_f ipv,
849: pay_balance_feeds_f blf,
850: pay_balance_types blt
851: WHERE asa.assignment_id = p_asg_id
852: AND asa.tax_unit_id = p_gre
853: AND pya.payroll_id = p_payroll_id
854: AND pya.payroll_action_id = asa.payroll_action_id

Line 1006: pay_balance_types blt

1002: pay_element_types_f ele,
1003: pay_element_classifications elc,
1004: pay_input_values_f ipv,
1005: pay_balance_feeds_f blf,
1006: pay_balance_types blt
1007: WHERE asa.assignment_id = p_asg_id
1008: AND asa.tax_unit_id = p_gre
1009: AND pya.payroll_id = p_payroll_id
1010: AND pya.payroll_action_id = asa.payroll_action_id

Line 1982: pay_balance_types pbt

1978: CURSOR cur_bal_type_id IS
1979: SELECT
1980: pbt.balance_type_id
1981: FROM
1982: pay_balance_types pbt
1983: WHERE
1984: pbt.balance_name = 'EI Hours' and
1985: pbt.legislation_code = 'CA';
1986:

Line 1987: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

1983: WHERE
1984: pbt.balance_name = 'EI Hours' and
1985: pbt.legislation_code = 'CA';
1986:
1987: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
1988:
1989: /* CURSOR csr_get_element_id (p_dp_or_de VARCHAR2)
1990: IS
1991: SELECT DISTINCT ele.element_type_id