APPS.PAY_SG_DEDUCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 705: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

701: */
702:
703: function check_if_retro
704: (
705: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
706: p_date_earned in pay_payroll_actions.date_earned%TYPE
707: ) return varchar2 IS
708:
709: cursor c_get_creator_type(

Line 710: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

706: p_date_earned in pay_payroll_actions.date_earned%TYPE
707: ) return varchar2 IS
708:
709: cursor c_get_creator_type(
710: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
711: c_date_earned in pay_payroll_actions.date_earned%TYPE
712: ) is
713: SELECT creator_type
714: FROM pay_element_entries_f pee

Line 714: FROM pay_element_entries_f pee

710: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
711: c_date_earned in pay_payroll_actions.date_earned%TYPE
712: ) is
713: SELECT creator_type
714: FROM pay_element_entries_f pee
715: WHERE pee.element_entry_id = c_element_entry_id
716: AND c_date_earned between pee.effective_start_date and pee.effective_end_date;
717:
718: l_creator_type pay_element_entries_f.creator_type%TYPE;

Line 718: l_creator_type pay_element_entries_f.creator_type%TYPE;

714: FROM pay_element_entries_f pee
715: WHERE pee.element_entry_id = c_element_entry_id
716: AND c_date_earned between pee.effective_start_date and pee.effective_end_date;
717:
718: l_creator_type pay_element_entries_f.creator_type%TYPE;
719: IS_retro_payment varchar2(10);
720:
721: begin
722:

Line 762: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE

758: function which_retro_method
759: (
760: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
761: p_date_earned in pay_payroll_actions.date_earned%TYPE,
762: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
763: ) return varchar2 IS
764:
765: /*
766: ** Bug#5353558 Cursor to look for any CPF elements exists in the Element Set of

Line 771: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,

767: ** the retro pay, which has created this retro element.
768: */
769:
770: cursor get_retro_method
771: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,
772: c_date_earned in pay_payroll_actions.date_earned%TYPE,
773: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
774: ) is
775: select pet.element_name

Line 773: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE

769:
770: cursor get_retro_method
771: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,
772: c_date_earned in pay_payroll_actions.date_earned%TYPE,
773: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
774: ) is
775: select pet.element_name
776: from pay_element_entries_f pee,
777: pay_assignment_actions paa,

Line 776: from pay_element_entries_f pee,

772: c_date_earned in pay_payroll_actions.date_earned%TYPE,
773: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
774: ) is
775: select pet.element_name
776: from pay_element_entries_f pee,
777: pay_assignment_actions paa,
778: pay_payroll_actions ppa,
779: pay_element_sets pes,
780: pay_element_type_rules petr,

Line 797: from pay_element_entries_f pee,

793: and pet.element_name like '%CPF%'
794: and pet.legislation_code = 'SG'
795: union all
796: select pec.classification_name
797: from pay_element_entries_f pee,
798: pay_assignment_actions paa,
799: pay_payroll_actions ppa,
800: pay_element_sets pes,
801: pay_ele_classification_rules pecr,

Line 1277: pay_element_entries_f pee,

1273: cursor c_pay_element_entries
1274: is
1275: select sum(peev.screen_entry_value)
1276: from pay_element_entry_values_f peev,
1277: pay_element_entries_f pee,
1278: pay_element_types_f pet,
1279: pay_input_values_f piv,
1280: pay_element_classifications pec
1281: where pee.assignment_id = p_assignment_id